hpv_campaign_dates

Table: hpv_campaign_dates

The hpv_campaign_dates table stores all the dates relevant to HPV vaccination campaigns.
It is used for scheduling, tracking, and reporting campaign activities.

---

Columns

Column Name	Data Type	Constraints	Description
Id	int(11)	NOT NULL, AUTO_INCREMENT, PRIMARY KEY	Unique identifier for each campaign date record
date	date	NOT NULL	Date of the HPV campaign activity

---

Indexes

1. PRIMARY - Primary key on Id
2. campaign_date - Index on date using BTREE

---

Foreign Key Relations

• None

---

Usage Notes

• Contains all scheduled or historical dates for HPV campaigns.
• Indexed on date for fast lookups and reporting.
• Supports planning, reminders, and campaign progress tracking.